﻿CREATE TABLE [dbo].[Food] (
    [FoodId]     INT             IDENTITY (1, 1) NOT NULL,
    [Name]       NVARCHAR (50)   NULL,
    [FoodTypeId] INT             NULL,
    [Price]      DECIMAL (18, 2) NULL,
    [Unit]       NVARCHAR (50)   NULL,
    [Created]    DATETIME        NULL,
    CONSTRAINT [PK_Food] PRIMARY KEY CLUSTERED ([FoodId] ASC),
    CONSTRAINT [FK_Food_FoodType] FOREIGN KEY ([FoodTypeId]) REFERENCES [dbo].[FoodType] ([FoodTypeId])
);

